
 

use  "C:\Users\Administrator\Desktop\Corporate data.dta",clear
tab year,missing

 xtset panelidnew year 
 
 ********Table2  partB
  sum  income revenue profit salestax salesfee tax paytax wage 
  sum managemcosts laborprofitratio capitalprofitratio newproduct newproductrate exportsize   
sum size Age labor debt Right subsidy
 
   
 
 ****************Table 12
 
xtreg income  TT  size Age labor debt Right subsidy  i.year    ,fe       
est store a_1
xtreg revenue TT  size Age labor debt Right subsidy i.year    ,fe    
est store a_2
xtreg profit TT  size Age labor debt Right subsidy i.year    ,fe    
est store a_3
xtreg income  TT  size Age labor debt Right subsidy i.year if year>2005  ,fe     
est store a_4
xtreg revenue TT  size Age labor debt Right subsidy i.year if year>2005  ,fe    
est store a_5
xtreg profit  TT size Age labor debt Right subsidy i.year if year>2005  ,fe    
est store a_6


  
 
 esttab a_* using myout1.csv,replace ///
       star(* 0.1 ** 0.05 *** 0.01) ///
	   b(%6.3f) se(%6.3f) compress nogap ///     
	  stats(N F r2 ,fmt(%12.0f %9.3f) ) varwidth(20)
 
 

*****************Table 13
 
 
xtreg salestax TT  size Age labor debt Right subsidy i.year    ,fe    
est store c_1
xtreg salesfee TT  size Age labor debt Right subsidy i.year    ,fe    
est store c_2
xtreg tax  TT  size Age labor debt Right subsidy i.year    ,fe    
est store c_3
xtreg paytax TT  size Age labor debt Right subsidy i.year    ,fe    
est store c_4
xtreg wage TT  size Age labor debt Right subsidy i.year    ,fe    
est store c_5
 
 
 esttab c_* using myout1.csv,replace ///
       star(* 0.1 ** 0.05 *** 0.01) ///
	   b(%6.3f) se(%6.3f) compress nogap ///     
	  stats(N F r2 ,fmt(%12.0f %9.3f) ) varwidth(20)
 
 
 **************Table 15
 
 xtreg managemcosts  TT  i.year    ,fe     
est store y_1
xtreg managemcosts TT  size Age labor debt Right subsidy i.year   ,fe    
est store y_2
xtreg laborprofitratio  TT  i.year    ,fe     
est store y_3
xtreg laborprofitratio TT  size Age labor debt Right subsidy i.year   ,fe    
est store y_4
xtreg capitalprofitratio  TT  i.year    ,fe     
est store y_5
xtreg capitalprofitratio TT  size Age labor debt Right subsidy i.year   ,fe    
est store y_6

  

 esttab y_* using myout1.csv,replace ///
       star(* 0.1 ** 0.05 *** 0.01) ///
	   b(%6.3f) se(%6.3f) compress nogap ///     
	  stats(N F r2 ,fmt(%12.0f %9.3f) ) varwidth(20)
 
 
     
*************************Table 16  
 

xtreg tfp_OLS TT   i.year    ,fe    
est store C_1
xtreg tfp_OLS TT  size Age labor debt Right subsidy i.year   ,fe    
est store C_2
xtreg tfp_OLS TT  size Age labor debt Right subsidy i.year if year>2005  ,fe    
est store C_3
xtreg tfp_LP TT   i.year    ,fe    
est store C_4
xtreg tfp_LP TT  size Age labor debt Right subsidy i.year   ,fe    
est store C_5
xtreg tfp_LP TT  size Age labor debt Right subsidy i.year    ,fe    
est store C_6

  

 esttab C_* using myout1.csv,replace ///
       star(* 0.1 ** 0.05 *** 0.01) ///
	   b(%6.3f) se(%6.3f) compress nogap ///     
	  stats(N F r2 ,fmt(%12.0f %9.3f) ) varwidth(20)
 
  
 **************************Table 17
 
xtreg  newproduct  TT  size Age labor debt Right subsidy i.year    ,fe     
est store x_1
xtreg newproductrate TT  size Age labor debt Right subsidy i.year    ,fe    
est store x_2
xtreg  exportsize TT  size Age labor debt Right subsidy i.year   ,fe    
est store x_3
xtreg  newproduct  TT  size Age labor debt Right subsidy i.year if year>2005  ,fe     
est store x_4
xtreg newproductrate TT  size Age labor debt Right subsidy i.year if year>2005  ,fe    
est store x_5
xtreg  exportsize TT size Age labor debt Right subsidy i.year if year>2005  ,fe    
est store x_6

 
 
   
esttab x_* using myout1.csv,replace ///
       star(* 0.1 ** 0.05 *** 0.01) ///
	   b(%6.3f) se(%6.3f) compress nogap ///     
	  stats(N F r2 ,fmt(%12.0f %9.3f) ) varwidth(20)
  
  

 